﻿CREATE PROCEDURE [dbo].[GetMilestones]
@ProjectID INT
AS
SELECT MilestoneID,
		ProjectID,
		TargetDate,
		Description,
		DollarAmount,
		HasBeenMet
FROM Milestones
WHERE ProjectID = @ProjectID

